<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">  
  <title>用户列表</title>
 </head>
 <body>
 
 <?php
  require_once('dbConn.php');
  require_once('myFanc.php');
  $id=$_GET['id'];

  connect();
  //编写sql语句
  $sql = "select * from flower where zq_id={$id}";
  //echo $sql.'<br/>';  
  $result = fetch_array($sql); 
   
 ?>
 <center><h3>用户列表</h3></center>
 <table align="center" width="80%" border=1> 
 <tr>
   <th>编号</th>
   <th>鲜花标题</th> 
   <th>鲜花图片文件名</th>  
   <th>鲜花产地</th>
   <th>鲜花简介</th>
   <th>添加鲜花时间</th>
   <th>点击量</th> 
   <th>操作</th>
 </tr>

 <?php
  foreach ($result as $row) {
   echo '<tr>';
   echo '<td>'.$row['zq_id'].'</td>';
   echo '<td>'.$row['zq_title'].'</td>';  
   echo '<td>'.$row['zq_pic'].'</td>';
   echo '<td>'.$row['zq_place'].'</td>';
   echo '<td>'.$row['zq_intro'].'</td>';
   echo '<td>'.$row['zq_adddate'].'</td>';
   echo '<td>'.$row['zq_hint'].'</td>';   
   echo '<td><a href="flowerEditForm.php?id='.$row['zq_id'].' ">修改</a> | 
   <a href="delflower.php?id='.$row['zq_id'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
   echo '</tr>';  
  }
  echo '</table>';  
  $totalrows = count($result);
  echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>";   
 ?>

 
 </body>
</html>
